﻿<%@ Page Title="" Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="myaccount_Default"%>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
        .auto-style2 {
            height: 57px;
        }
    .auto-style3 {
        height: 35px;
    }
    </style>
</asp:Content>

<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <h3>IT Assets Uploaded</h3>
    <div>
       
            <asp:DropDownList ID="DropDownList1" runat="server">
            </asp:DropDownList>
            <asp:TextBox ID="txtFind" runat="server" CssClass="textbox" Width="355px" CausesValidation="True"></asp:TextBox>
            <asp:Button ID="Button2" runat="server" Text="Search" CssClass="button" />
        
</div>
         <asp:UpdatePanel ID="UpdatePanel1" runat="server">
      <ContentTemplate>
          <asp:ScriptManager ID="ScriptManager1" runat="server">
           </asp:ScriptManager>
          
    
    
          <asp:SqlDataSource ID="SqlSearch" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" SelectCommand="sp_FindStringInTable" SelectCommandType="StoredProcedure">
              <SelectParameters>
                  <asp:QueryStringParameter DefaultValue="%" Name="stringToFind" QueryStringField="search_query" Type="String" />
                  <asp:Parameter DefaultValue="dbo" Name="schema" Type="String" />
                  <asp:Parameter DefaultValue="ita_items" Name="table" Type="String" />
                  <asp:Parameter Direction="ReturnValue" Name="RETURN_VALUE" Type="Int32" />
                  <asp:ControlParameter ControlID="DropDownList1" DefaultValue="" Name="author" PropertyName="SelectedValue" Type="String" />
                  <asp:Parameter DefaultValue="1000000" Name="limit" Type="String" />
                  <asp:Parameter DefaultValue="ita_key,assetno,company,store,serialno,assetclass,model,status" Name="tableslist" Type="String" />
              </SelectParameters>
          </asp:SqlDataSource>
    
          <table style="width:100%;">
              <tr>
                  <td>
                      &nbsp;</td>
                  <td style="text-align: right">
                      <asp:Button ID="Button3" runat="server" Text="Export to excel" Width="113px" />
                  </td>
              </tr>
              <tr>
                  <td>
                      <asp:Label ID="lblResultCount" runat="server" Font-Bold="True" Font-Italic="True"></asp:Label>
                  </td>
                  <td style="text-align: right">&nbsp;</td>
              </tr>
          </table>
         
    
          <asp:GridView ID="GridView2" runat="server" AllowPaging="True" AllowSorting="True" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlSearch" Width="100%" PageSize="15" Font-Names="Tahoma" Font-Size="8pt">
              <Columns>
                  <asp:CommandField ShowSelectButton="True" />
              </Columns>
              <FooterStyle BackColor="White" ForeColor="#000066" />
              <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
              <PagerSettings PageButtonCount="15" />
              <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Center" />
              <RowStyle ForeColor="#000066" />
              <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" />
              <SortedAscendingCellStyle BackColor="#F1F1F1" />
              <SortedAscendingHeaderStyle BackColor="#007DBB" />
              <SortedDescendingCellStyle BackColor="#CAC9C9" />
              <SortedDescendingHeaderStyle BackColor="#00547E" />
          </asp:GridView>
          <asp:SqlDataSource ID="SqlGetInfo" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" SelectCommand="SELECT ita_key, company, assetclass, store, assignedto, currentassignee, yearpurchased, datepurchased, supplier, datedelivered, assetno, devicetype, serialno, brand, model, specs, po, warranty, cost, invoiceno, recievedby, daterecieved, deployedby, dateofdeployment, status, lanip, gatewayip, os_software, other1, other2, date_added, UploadedBy, Assignee3, Assignee4, Assignee5 FROM ita_items WHERE (ita_key = @ita_key)">
              <SelectParameters>
                  <asp:QueryStringParameter Name="ita_key" QueryStringField="item" />
              </SelectParameters>
          </asp:SqlDataSource>
          <br />
          <asp:TextBox ID="lblLogs" runat="server" Visible="False">Failed</asp:TextBox>
          <asp:Panel ID="DetailsPanel" runat="server" Visible="False" >
    <br />
          <h4> Details :</h4>
          <hr />
    <br />

          <table style="width: 100%;">
              <tr>
                  <td class="auto-style2">&nbsp;</td>
                  <td class="auto-style2">

                      &nbsp;<asp:HyperLink ID="HyperLink2" runat="server" CssClass="ImageLinkSize">
                      <asp:Image ID="Image1" runat="server" Height="200px" Width="200px" ImageUrl="http://192.168.1.18:5231/imggen.aspx?PictureID=Default" />
                      </asp:HyperLink>
                          <br />
                      <asp:FileUpload ID="FileUpload1" runat="server" />
                  </td>
                  <td class="auto-style2">&nbsp;</td>
                  <td class="auto-style2">
                      &nbsp;</td>
              </tr>
              <tr>
                  <td class="auto-style3">Company</td>
                  <td class="auto-style3">
                      <asp:DropDownList ID="DropDownList2" runat="server" CssClass="textbox">
                          <asp:ListItem Value="KR">EPEI</asp:ListItem>
                          <asp:ListItem Value="SBC">CMI</asp:ListItem>
                          <asp:ListItem Value="KG">GBC</asp:ListItem>
                          <asp:ListItem Value="HO">Head Office</asp:ListItem>
                          <asp:ListItem Value="ERWIN">ERWIN</asp:ListItem>
                      </asp:DropDownList>
                  </td>
                  <td class="auto-style3">Store/Department</td>
                  <td class="auto-style3">
                      <asp:DropDownList ID="DropDownList3" runat="server" CssClass="textbox" DataSourceID="SqlDataSource1" DataTextField="storename" DataValueField="storename">
                      </asp:DropDownList>
                      
                  </td>
              </tr>
              <tr>
                  <td>Asset Class</td>
                  <td>
                      <asp:DropDownList ID="lstAssetClass" runat="server" CssClass="textbox" DataSourceID="assetSource" DataTextField="assetclass" DataValueField="assetclass">
                      </asp:DropDownList>
                      <asp:SqlDataSource ID="assetSource" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" SelectCommand="SELECT assetclass FROM ita_assetclass"></asp:SqlDataSource>
                  </td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
              </tr>
              <tr>
                  <td>Assignee 1</td>
                  <td>
                      <asp:TextBox ID="txtassignedTo" runat="server" CssClass="textbox"></asp:TextBox>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtassignedTo" Display="None" ErrorMessage="* Assigned To"></asp:RequiredFieldValidator>
                  </td>
                  <td>Assignee 4</td>
                  <td>
                      <asp:TextBox ID="txtassignee4" runat="server" CssClass="textbox"></asp:TextBox>
                  </td>
              </tr>
              <tr>
                  <td>Assignee 2</td>
                  <td>
                      <asp:TextBox ID="txtCurrentAssignee" runat="server" CssClass="textbox"></asp:TextBox>
                  </td>
                  <td>Assignee 5</td>
                  <td>
                      <asp:TextBox ID="txtassignee5" runat="server" CssClass="textbox"></asp:TextBox>
                  </td>
              </tr>
              <tr>
                  <td>Assignee 3</td>
                  <td>
                      <asp:TextBox ID="txtassignee3" runat="server" CssClass="textbox"></asp:TextBox>
                  </td>
                  <td>Asset Ending ID</td>
                  <td>
                      <asp:TextBox ID="txtAssetEndingID" runat="server"></asp:TextBox>
                  </td>
              </tr>
              <tr>
                  <td>Year Acquired</td>
                  <td>
                      <asp:TextBox ID="txtYearAcquired" runat="server" CssClass="textbox" TextMode="Date"></asp:TextBox>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="txtYearAcquired" Display="None" ErrorMessage="* Year"></asp:RequiredFieldValidator>
                  </td>
                  <td>Date Purchase</td>
                  <td>
                      <asp:TextBox ID="txtDatePurchased" runat="server" CssClass="textbox" TextMode="Date" ></asp:TextBox>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator14" runat="server" ControlToValidate="txtDatePurchased" Display="None" ErrorMessage="* Date Purchase"></asp:RequiredFieldValidator>
                  </td>
              </tr>
              <tr>
                  <td>Supplier</td>
                  <td>
                      <asp:TextBox ID="txtSupplier" runat="server" CssClass="textbox"></asp:TextBox>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="txtSupplier" Display="None" ErrorMessage="* Supplier"></asp:RequiredFieldValidator>
                  </td>
                  <td>Date Delivered</td>
                  <td>
                      <asp:TextBox ID="txtDateDelivered" runat="server" CssClass="textbox" TextMode="Date" ></asp:TextBox>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator15" runat="server" ControlToValidate="txtDateDelivered" Display="None" ErrorMessage="* Date Delivered"></asp:RequiredFieldValidator>
                  </td>
              </tr>
              <tr>
                  <td>Asset No.</td>
                  <td>
                      <asp:TextBox ID="txtAssetno" runat="server" CssClass="textbox" ></asp:TextBox>
                  </td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
              </tr>
              <tr>
                  <td>Device Type</td>
                  <td>
                      <asp:TextBox ID="txtdevicetype" runat="server" CssClass="textbox"></asp:TextBox>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="txtdevicetype" Display="None" ErrorMessage="* Device Type"></asp:RequiredFieldValidator>
                  </td>
                  <td>Serial No.</td>
                  <td>
                      <asp:TextBox ID="txtserial" runat="server" CssClass="textbox"></asp:TextBox>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="txtserial" Display="None" ErrorMessage="* Serial Number"></asp:RequiredFieldValidator>
                  </td>
              </tr>
              <tr>
                  <td>Brand</td>
                  <td>
                      <asp:TextBox ID="txtbrand" runat="server" CssClass="textbox"></asp:TextBox>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" ControlToValidate="txtbrand" Display="None" ErrorMessage="* Brand"></asp:RequiredFieldValidator>
                  </td>
                  <td>Model</td>
                  <td>
                      <asp:TextBox ID="txtmodel" runat="server" CssClass="textbox"></asp:TextBox>
                  </td>
              </tr>
              <tr>
                  <td style="vertical-align: top">Specs</td>
                  <td>
                      <asp:TextBox ID="txtspecss" runat="server" CssClass="multitextbox" TextMode="MultiLine"></asp:TextBox>
                  </td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
              </tr>
              <tr>
                  <td>P.O.</td>
                  <td>
                      <asp:TextBox ID="txtpo" runat="server" CssClass="textbox"></asp:TextBox>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator9" runat="server" ControlToValidate="txtpo" Display="None" ErrorMessage="* P.O."></asp:RequiredFieldValidator>
                  </td>
                  <td>Warranty</td>
                  <td>
                      <asp:TextBox ID="txtwarranty" runat="server" CssClass="textbox"></asp:TextBox>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator10" runat="server" ControlToValidate="txtwarranty" Display="None" ErrorMessage="* Warranty"></asp:RequiredFieldValidator>
                  </td>
              </tr>
              <tr>
                  <td>Cost</td>
                  <td>
                      <asp:TextBox ID="txtcost" runat="server" CssClass="textbox"></asp:TextBox>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator11" runat="server" ControlToValidate="txtcost" Display="None" ErrorMessage="* Cost"></asp:RequiredFieldValidator>
                  </td>
                  <td>Invoice No.</td>
                  <td>
                      <asp:TextBox ID="txtinvoice" runat="server" CssClass="textbox"></asp:TextBox>
                  </td>
              </tr>
              <tr>
                  <td>Received By</td>
                  <td>
                      <asp:TextBox ID="txtrecieved" runat="server" CssClass="textbox"></asp:TextBox>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator12" runat="server" ControlToValidate="txtrecieved" Display="None" ErrorMessage="* Received By"></asp:RequiredFieldValidator>
                  </td>
                  <td>Date Received</td>
                  <td>
                      <asp:TextBox ID="txtdaterecieved" runat="server" CssClass="textbox" ></asp:TextBox>
                  </td>
              </tr>
              <tr>
                  <td>Deployed By</td>
                  <td>
                      <asp:TextBox ID="txtdeployedby" runat="server" CssClass="textbox"></asp:TextBox>
                  </td>
                  <td>Date of Deployment</td>
                  <td>
                      <asp:TextBox ID="txtdatedeployement" runat="server" CssClass="textbox" TextMode="Date" ></asp:TextBox>
                  </td>
              </tr>
              <tr>
                  <td>Status</td>
                  <td>
                      <asp:TextBox ID="txtstatus" runat="server" CssClass="textbox"></asp:TextBox>
                      <asp:RequiredFieldValidator ID="RequiredFieldValidator13" runat="server" ControlToValidate="txtstatus" Display="None" ErrorMessage="* Status"></asp:RequiredFieldValidator>
                  </td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
              </tr>
              <tr>
                  <td>LAN IP</td>
                  <td>
                      <asp:TextBox ID="txtlanip" runat="server" CssClass="textbox"></asp:TextBox>
                  </td>
                  <td>Gateway IP</td>
                  <td>
                      <asp:TextBox ID="txtgatewayip" runat="server" CssClass="textbox"></asp:TextBox>
                  </td>
              </tr>
              <tr>
                  <td>OS/Software</td>
                  <td>
                      <asp:TextBox ID="txtos" runat="server" CssClass="textbox"></asp:TextBox>
                  </td>
                  <td>&nbsp;</td>
                  <td>&nbsp;</td>
              </tr>
              <tr>
                  <td style="vertical-align: top">Other Details</td>
                  <td>
                      <asp:TextBox ID="txtother1" runat="server" CssClass="multitextbox" TextMode="MultiLine"></asp:TextBox>
                  </td>
                  <td style="vertical-align: top">Other Details</td>
                  <td>
                      <asp:TextBox ID="txtother2" runat="server" CssClass="multitextbox" TextMode="MultiLine"></asp:TextBox>
                  </td>
              </tr>
              <tr>
                  <td>&nbsp;</td>
                  <td style="vertical-align: middle">
                      <asp:Button ID="Button1" runat="server" CssClass="button" Text="Update" Width="131px" />
                      <asp:Button ID="Button4" runat="server" CssClass="button" Text="Delete" Width="130px" />
                  </td>
                  <td>&nbsp;</td>
                  <td>
                      &nbsp;</td>
              </tr>
          </table>
          <asp:SqlDataSource ID="SqlUpdateRecord" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" DeleteCommand="DELETE FROM [ita_items] WHERE [ita_key] = @ita_key" InsertCommand="INSERT INTO [ita_items] ([company], [assetclass], [store], [assignedto], [currentassignee], [yearpurchased], [datepurchased], [supplier], [datedelivered], [assetno], [devicetype], [serialno], [brand], [model], [specs], [po], [warranty], [cost], [invoiceno], [recievedby], [daterecieved], [deployedby], [dateofdeployment], [status], [lanip], [gatewayip], [os_software], [other1], [other2], [date_added], [UploadedBy]) VALUES (@company, @assetclass, @store, @assignedto, @currentassignee, @yearpurchased, @datepurchased, @supplier, @datedelivered, @assetno, @devicetype, @serialno, @brand, @model, @specs, @po, @warranty, @cost, @invoiceno, @recievedby, @daterecieved, @deployedby, @dateofdeployment, @status, @lanip, @gatewayip, @os_software, @other1, @other2, @date_added, @UploadedBy)" SelectCommand="SELECT * FROM [ita_items]" UpdateCommand="UPDATE ita_items SET company = @company, assetclass = @assetclass, store = @store, assignedto = @assignedto, currentassignee = @currentassignee, yearpurchased = @yearpurchased, datepurchased = @datepurchased, supplier = @supplier, datedelivered = @datedelivered, assetno = @assetno, devicetype = @devicetype, serialno = @serialno, brand = @brand, model = @model, specs = @specs, po = @po, warranty = @warranty, cost = @cost, invoiceno = @invoiceno, recievedby = @recievedby, daterecieved = @daterecieved, deployedby = @deployedby, dateofdeployment = @dateofdeployment, status = @status, lanip = @lanip, gatewayip = @gatewayip, os_software = @os_software, other1 = @other1, other2 = @other2, date_added = @date_added, Assignee4 = @Assignee4, Assignee3 = @Assignee3, Assignee5 = @Assignee5 WHERE (ita_key = @ita_key)">
              <DeleteParameters>
                  <asp:QueryStringParameter Name="ita_key" QueryStringField="item" Type="Int64" />
              </DeleteParameters>
              <InsertParameters>
                  <asp:Parameter Name="company" Type="String" />
                  <asp:Parameter Name="assetclass" Type="String" />
                  <asp:Parameter Name="store" Type="String" />
                  <asp:Parameter Name="assignedto" Type="String" />
                  <asp:Parameter Name="currentassignee" Type="String" />
                  <asp:Parameter Name="yearpurchased" Type="String" />
                  <asp:Parameter Name="datepurchased" Type="String" />
                  <asp:Parameter Name="supplier" Type="String" />
                  <asp:Parameter Name="datedelivered" Type="String" />
                  <asp:Parameter Name="assetno" Type="String" />
                  <asp:Parameter Name="devicetype" Type="String" />
                  <asp:Parameter Name="serialno" Type="String" />
                  <asp:Parameter Name="brand" Type="String" />
                  <asp:Parameter Name="model" Type="String" />
                  <asp:Parameter Name="specs" Type="String" />
                  <asp:Parameter Name="po" Type="String" />
                  <asp:Parameter Name="warranty" Type="String" />
                  <asp:Parameter Name="cost" Type="String" />
                  <asp:Parameter Name="invoiceno" Type="String" />
                  <asp:Parameter Name="recievedby" Type="String" />
                  <asp:Parameter Name="daterecieved" Type="String" />
                  <asp:Parameter Name="deployedby" Type="String" />
                  <asp:Parameter Name="dateofdeployment" Type="String" />
                  <asp:Parameter Name="status" Type="String" />
                  <asp:Parameter Name="lanip" Type="String" />
                  <asp:Parameter Name="gatewayip" Type="String" />
                  <asp:Parameter Name="os_software" Type="String" />
                  <asp:Parameter Name="other1" Type="String" />
                  <asp:Parameter Name="other2" Type="String" />
                  <asp:Parameter Name="date_added" Type="String" />
                  <asp:Parameter Name="UploadedBy" Type="String" />
                  <asp:Parameter Name="Assignee3" Type="String" />
                  <asp:Parameter Name="Assignee4" Type="String" />
                  <asp:Parameter Name="Assignee5" Type="String" />
              </InsertParameters>
              <UpdateParameters>
                  <asp:ControlParameter ControlID="DropDownList2" Name="company" PropertyName="SelectedValue" Type="String" />
                  <asp:ControlParameter ControlID="lstAssetClass" Name="assetclass" PropertyName="SelectedValue" Type="String" />
                  <asp:ControlParameter ControlID="DropDownList3" Name="store" PropertyName="SelectedValue" Type="String" />
                  <asp:ControlParameter ControlID="txtassignedTo" Name="assignedto" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtCurrentAssignee" Name="currentassignee" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtYearAcquired" Name="yearpurchased" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtDatePurchased" Name="datepurchased" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtSupplier" Name="supplier" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtDateDelivered" Name="datedelivered" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtAssetno" Name="assetno" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtdevicetype" Name="devicetype" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtserial" Name="serialno" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtbrand" Name="brand" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtmodel" Name="model" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtspecss" Name="specs" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtpo" Name="po" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtwarranty" Name="warranty" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtcost" Name="cost" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtinvoice" Name="invoiceno" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtrecieved" Name="recievedby" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtrecieved" Name="daterecieved" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtdeployedby" Name="deployedby" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtdatedeployement" Name="dateofdeployment" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtstatus" Name="status" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtlanip" Name="lanip" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtgatewayip" Name="gatewayip" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtos" Name="os_software" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtother1" Name="other1" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtother2" Name="other2" PropertyName="Text" Type="String" />
                  <asp:QueryStringParameter Name="ita_key" QueryStringField="item" Type="Int64" />
                  <asp:SessionParameter Name="date_added" SessionField="DateNow" />
                  <asp:ControlParameter ControlID="txtassignee3" Name="Assignee3" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtassignee4" Name="Assignee4" PropertyName="Text" Type="String" />
                  <asp:ControlParameter ControlID="txtassignee5" Name="Assignee5" PropertyName="Text" Type="String" />
              
              </UpdateParameters>
          </asp:SqlDataSource><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" SelectCommand="SELECT * FROM [stores]"></asp:SqlDataSource>
    <br />
               <asp:SqlDataSource ID="SqlAssetCount" runat="server" ConnectionString="<%$ ConnectionStrings:Management_Info_SysConnectionString %>" SelectCommand="SELECT [ita_assetnumber] FROM [numbercounter]"></asp:SqlDataSource>
               <br />
          </asp:Panel>
          </ContentTemplate>
         </asp:UpdatePanel> 
</asp:Content>

